<?xml version="1.0" encoding="iso-8859-1"?>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
  <html xmlns="http://www.w3.org/1999/xhtml">
		<head>
			<!-- template designed by Marco Von Ballmoos -->
			<title>Docs For Class JSONQuery</title>
			<link rel="stylesheet" href="../media/stylesheet.css" />
			<meta http-equiv='Content-Type' content='text/html; charset=iso-8859-1'/>
		</head>
		<body>
			<div class="page-body">			
<h2 class="class-name">Class JSONQuery</h2>

<a name="sec-description"></a>
<div class="info-box">
	<div class="info-box-title">Description</div>
	<div class="nav-bar">
					<span class="disabled">Description</span> |
													<a href="#sec-var-summary">Vars</a> (<a href="#sec-vars">details</a>)
						|											<a href="#sec-method-summary">Methods</a> (<a href="#sec-methods">details</a>)
						
					</div>
	<div class="info-box-body">
        		<!-- ========== Info from phpDoc block ========= -->
<p class="short-description">I am a JSON Query builder</p>
<p class="description"><p>Here is a inline example of how to create your json when sending it.</p><p><div class="src-code"><ol><li><div class="src-line">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<span class="src-var">$flexJSON&nbsp;</span>=&nbsp;<span class="src-str">'[{&quot;table&quot;:&quot;TABLENAME&quot;,&quot;objectName&quot;:&quot;FIELDNAME&quot;,&quot;objectValue&quot;:&quot;FIELDVALUE&quot;,&quot;database&quot;:&quot;DATABASE&quot;,&quot;tableKey&quot;:&quot;PRI&nbsp;KEY&quot;,&quot;objectKey&quot;:&quot;RECORD&nbsp;KEY&quot;}]'</span><span class="src-sym">;</span></div></li>
<li><div class="src-line">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<span class="src-var">$j&nbsp;</span>=&nbsp;<span class="src-key">new&nbsp;</span><span class="src-id"><a href="../MySQLService/JSONQuery.html">JSONQuery</a></span><span class="src-sym">(&nbsp;</span><span class="src-str">'host'</span><span class="src-sym">,&nbsp;</span><span class="src-str">'user'</span><span class="src-sym">,&nbsp;</span><span class="src-str">'pass'&nbsp;</span><span class="src-sym">)</span><span class="src-sym">;</span></div></li>
<li><div class="src-line">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<span class="src-var">$j</span><span class="src-sym">-&gt;</span><a href="../MySQLService/JSONQuery.html#methoddump">dump</a><span class="src-sym">(&nbsp;</span><span class="src-var">$j</span><span class="src-sym">-&gt;</span><a href="../MySQLService/JSONQuery.html#methodbuildQuery">buildQuery</a><span class="src-sym">(&nbsp;</span><span class="src-var">$flexJSON</span><span class="src-sym">,&nbsp;</span><span class="src-str">'INSERT'&nbsp;</span><span class="src-sym">)</span><span class="src-sym">,&nbsp;</span><span class="src-str">'INSERT&nbsp;JSON&nbsp;'&nbsp;</span><span class="src-sym">)</span><span class="src-sym">;</span></div></li>
<li><div class="src-line">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<span class="src-var">$j</span><span class="src-sym">-&gt;</span><a href="../MySQLService/JSONQuery.html#methoddump">dump</a><span class="src-sym">(&nbsp;</span><span class="src-var">$j</span><span class="src-sym">-&gt;</span><a href="../MySQLService/JSONQuery.html#methodbuildQuery">buildQuery</a><span class="src-sym">(&nbsp;</span><span class="src-var">$flexJSON</span><span class="src-sym">,&nbsp;</span><span class="src-str">'UPDATE'&nbsp;</span><span class="src-sym">)</span><span class="src-sym">,&nbsp;</span><span class="src-str">'UPDATE&nbsp;JSON'&nbsp;</span><span class="src-sym">)</span><span class="src-sym">;</span></div></li>
<li><div class="src-line">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<span class="src-var">$j</span><span class="src-sym">-&gt;</span><a href="../MySQLService/JSONQuery.html#methoddump">dump</a><span class="src-sym">(&nbsp;</span><span class="src-var">$j</span><span class="src-sym">-&gt;</span><a href="../MySQLService/JSONQuery.html#methodbuildQuery">buildQuery</a><span class="src-sym">(&nbsp;</span><span class="src-var">$flexJSON</span><span class="src-sym">,&nbsp;</span><span class="src-str">'DELETE'&nbsp;</span><span class="src-sym">)</span><span class="src-sym">,&nbsp;</span><span class="src-str">'DELETE&nbsp;JSON'&nbsp;</span><span class="src-sym">)</span><span class="src-sym">;</span></div></li>
<li><div class="src-line">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<span class="src-var">$j</span><span class="src-sym">-&gt;</span><a href="../MySQLService/JSONQuery.html#methodsetJSONString">setJSONString</a><span class="src-sym">(&nbsp;</span><span class="src-var">$flexJSON&nbsp;</span><span class="src-sym">)</span><span class="src-sym">;</span></div></li>
<li><div class="src-line">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<span class="src-var">$j</span><span class="src-sym">-&gt;</span><a href="../MySQLService/JSONQuery.html#methoddump">dump</a><span class="src-sym">(&nbsp;</span><span class="src-var">$j</span><span class="src-sym">-&gt;</span><a href="../MySQLService/JSONQuery.html#methodgetJSONString">getJSONString</a><span class="src-sym">(</span><span class="src-sym">)</span><span class="src-sym">,&nbsp;</span><span class="src-str">'JSON&nbsp;STRING'&nbsp;</span><span class="src-sym">)</span><span class="src-sym">;</span></div></li>
</ol></div></p></p>
	<ul class="tags">
				<li><span class="field">author:</span> Jonnie Spratley</li>
				<li><span class="field">version:</span> 0.7</li>
				<li><span class="field">copyright:</span> 2009 http://jonniespratley.com</li>
			</ul>
		<p class="notes">
			Located in <a class="field" href="_JSONQuery.php.html">/JSONQuery.php</a> (line <span class="field"><a href="../__filesource/fsource_MySQLService__JSONQuery.php.html#a22">22</a></span>)
		</p>
		
				
		<pre></pre>
	
			</div>
</div>



	<a name="sec-var-summary"></a>
	<div class="info-box">
		<div class="info-box-title">Variable Summary</span></div>
		<div class="nav-bar">
			<a href="#sec-description">Description</a> |
						<span class="disabled">Vars</span> (<a href="#sec-vars">details</a>)
							| 
									<a href="#sec-method-summary">Methods</a> (<a href="#sec-methods">details</a>)
							
								</div>
		<div class="info-box-body">
			<div class="var-summary">
																																																<div class="var-title">
					<span class="var-type">mixed</span>
					<a href="#$jsonArray" title="details" class="var-name">$jsonArray</a>
				</div>
																<div class="var-title">
					<span class="var-type">mixed</span>
					<a href="#$jsonQuery" title="details" class="var-name">$jsonQuery</a>
				</div>
																<div class="var-title">
					<span class="var-type">mixed</span>
					<a href="#$jsonString" title="details" class="var-name">$jsonString</a>
				</div>
																<div class="var-title">
					<span class="var-type">mixed</span>
					<a href="#$mysqli" title="details" class="var-name">$mysqli</a>
				</div>
											</div>
		</div>
	</div>

	<a name="sec-method-summary"></a>
	<div class="info-box">
		<div class="info-box-title">Method Summary</span></div>
		<div class="nav-bar">
			<a href="#sec-description">Description</a> |
																		<a href="#sec-var-summary">Vars</a> (<a href="#sec-vars">details</a>)
				 
				|
						<span class="disabled">Methods</span> (<a href="#sec-methods">details</a>)
		</div>
		<div class="info-box-body">			
			<div class="method-summary">
																																																																																																				
												<div class="method-definition">
											<span class="method-result">JSONQuery</span>
										<a href="#__construct" title="details" class="method-name">__construct</a>
											(<span class="var-type">[database]</span>&nbsp;<span class="var-name">$link</span>)
									</div>
																<div class="method-definition">
											<span class="method-result">unknown</span>
										<a href="#buildQuery" title="details" class="method-name">buildQuery</a>
											(<span class="var-type">[json]</span>&nbsp;<span class="var-name">$json</span>, <span class="var-type">[string]</span>&nbsp;<span class="var-name">$type</span>, [<span class="var-type">[boolean]</span>&nbsp;<span class="var-name">$autoInsert</span> = <span class="var-default">false</span>])
									</div>
																<div class="method-definition">
											<span class="method-result">void</span>
										<a href="#dump" title="details" class="method-name">dump</a>
											(<span class="var-type">[var]</span>&nbsp;<span class="var-name">$var</span>, [<span class="var-type">[string]</span>&nbsp;<span class="var-name">$name</span> = <span class="var-default">'Variable Dump'</span>])
									</div>
																<div class="method-definition">
											<span class="method-result">associative</span>
										<a href="#getJSONArray" title="details" class="method-name">getJSONArray</a>
										()
									</div>
																<div class="method-definition">
											<span class="method-result">json</span>
										<a href="#getJSONString" title="details" class="method-name">getJSONString</a>
										()
									</div>
																<div class="method-definition">
											<span class="method-result">sql</span>
										<a href="#getQuery" title="details" class="method-name">getQuery</a>
										()
									</div>
																<div class="method-definition">
											<span class="method-result">void</span>
										<a href="#setJSONArray" title="details" class="method-name">setJSONArray</a>
											(<span class="var-type"></span>&nbsp;<span class="var-name">$json</span>, <span class="var-type">associative</span>&nbsp;<span class="var-name">$jsonArray</span>)
									</div>
																<div class="method-definition">
											<span class="method-result">void</span>
										<a href="#setJSONQuery" title="details" class="method-name">setJSONQuery</a>
											(<span class="var-type">string</span>&nbsp;<span class="var-name">$query</span>)
									</div>
																<div class="method-definition">
											<span class="method-result">void</span>
										<a href="#setJSONString" title="details" class="method-name">setJSONString</a>
											(<span class="var-type">json</span>&nbsp;<span class="var-name">$jsonString</span>)
									</div>
																<div class="method-definition">
											<span class="method-result">void</span>
										<a href="#_batchQuery" title="details" class="method-name">_batchQuery</a>
											(<span class="var-type">[array]</span>&nbsp;<span class="var-name">$sql</span>)
									</div>
																<div class="method-definition">
											<span class="method-result">void</span>
										<a href="#_filterTable" title="details" class="method-name">_filterTable</a>
											(<span class="var-type"></span>&nbsp;<span class="var-name">$s</span>)
									</div>
																<div class="method-definition">
											<span class="method-result">escaped</span>
										<a href="#_sqlQuote" title="details" class="method-name">_sqlQuote</a>
											(<span class="var-type">[string]</span>&nbsp;<span class="var-name">$str</span>)
									</div>
								</div>
		</div>
	</div>		

	<a name="sec-vars"></a>
	<div class="info-box">
		<div class="info-box-title">Variables</div>
		<div class="nav-bar">
			<a href="#sec-description">Description</a> |
										<a href="#sec-var-summary">Vars</a> (<span class="disabled">details</span>)
						
			
										| 
									<a href="#sec-method-summary">Methods</a> (<a href="#sec-methods">details</a>)
							
					</div>
		<div class="info-box-body">
			<a name="var$jsonArray" id="$jsonArray"><!-- --></A>
<div class="evenrow">

	<div class="var-header">
		<span class="var-title">
			<span class="var-type">mixed</span>
			<span class="var-name">$jsonArray</span>
						(line <span class="line-number"><a href="../__filesource/fsource_MySQLService__JSONQuery.php.html#a25">25</a></span>)
		</span>
	</div>

	<!-- ========== Info from phpDoc block ========= -->
	<ul class="tags">
				<li><span class="field">access:</span> private</li>
			</ul>
	
	
		
		

</div>
<a name="var$jsonQuery" id="$jsonQuery"><!-- --></A>
<div class="oddrow">

	<div class="var-header">
		<span class="var-title">
			<span class="var-type">mixed</span>
			<span class="var-name">$jsonQuery</span>
						(line <span class="line-number"><a href="../__filesource/fsource_MySQLService__JSONQuery.php.html#a27">27</a></span>)
		</span>
	</div>

	<!-- ========== Info from phpDoc block ========= -->
	<ul class="tags">
				<li><span class="field">access:</span> private</li>
			</ul>
	
	
		
		

</div>
<a name="var$jsonString" id="$jsonString"><!-- --></A>
<div class="evenrow">

	<div class="var-header">
		<span class="var-title">
			<span class="var-type">mixed</span>
			<span class="var-name">$jsonString</span>
						(line <span class="line-number"><a href="../__filesource/fsource_MySQLService__JSONQuery.php.html#a26">26</a></span>)
		</span>
	</div>

	<!-- ========== Info from phpDoc block ========= -->
	<ul class="tags">
				<li><span class="field">access:</span> private</li>
			</ul>
	
	
		
		

</div>
<a name="var$mysqli" id="$mysqli"><!-- --></A>
<div class="oddrow">

	<div class="var-header">
		<span class="var-title">
			<span class="var-type">mixed</span>
			<span class="var-name">$mysqli</span>
						(line <span class="line-number"><a href="../__filesource/fsource_MySQLService__JSONQuery.php.html#a24">24</a></span>)
		</span>
	</div>

	<!-- ========== Info from phpDoc block ========= -->
	<ul class="tags">
				<li><span class="field">access:</span> private</li>
			</ul>
	
	
		
		

</div>
						
		</div>
	</div>
	
	<a name="sec-methods"></a>
	<div class="info-box">
		<div class="info-box-title">Methods</div>
		<div class="nav-bar">
			<a href="#sec-description">Description</a> |
															<a href="#sec-var-summary">Vars</a> (<a href="#sec-vars">details</a>)
																	<a href="#sec-method-summary">Methods</a> (<span class="disabled">details</span>)
						
		</div>
		<div class="info-box-body">
			<A NAME='method_detail'></A>

<a name="method__construct" id="__construct"><!-- --></a>
<div class="evenrow">
	
	<div class="method-header">
		<span class="method-title">Constructor __construct</span> (line <span class="line-number"><a href="../__filesource/fsource_MySQLService__JSONQuery.php.html#a34">34</a></span>)
	</div> 
	
	<!-- ========== Info from phpDoc block ========= -->
<p class="short-description">Database Link</p>
	<ul class="tags">
				<li><span class="field">access:</span> public</li>
			</ul>
	
	<div class="method-signature">
		<span class="method-result">JSONQuery</span>
		<span class="method-name">
			__construct
		</span>
					(<span class="var-type">[database]</span>&nbsp;<span class="var-name">$link</span>)
			</div>
	
			<ul class="parameters">
					<li>
				<span class="var-type">[database]</span>
				<span class="var-name">$link</span>			</li>
				</ul>
		
			
	</div>
<a name="methodbuildQuery" id="buildQuery"><!-- --></a>
<div class="oddrow">
	
	<div class="method-header">
		<span class="method-title">buildQuery</span> (line <span class="line-number"><a href="../__filesource/fsource_MySQLService__JSONQuery.php.html#a51">51</a></span>)
	</div> 
	
	<!-- ========== Info from phpDoc block ========= -->
<p class="short-description">I build a INSERT/UPDATE/DELETE from a json string.</p>
<p class="description"><p>I can either auto update the database, or return the sql. 	<div class="src-code"><ol><li><div class="src-line">&nbsp;<span class="src-sym">[</span><span class="src-sym">{</span><span class="src-str">&quot;table&quot;</span>:<span class="src-str">&quot;TABLENAME&quot;</span><span class="src-sym">,</span><span class="src-str">&quot;objectName&quot;</span>:<span class="src-str">&quot;FIELDNAME&quot;</span><span class="src-sym">,</span><span class="src-str">&quot;objectValue&quot;</span>:<span class="src-str">&quot;FIELDVALUE&quot;</span><span class="src-sym">,</span><span class="src-str">&quot;database&quot;</span>:<span class="src-str">&quot;DATABASE&quot;</span><span class="src-sym">,</span><span class="src-str">&quot;tableKey&quot;</span>:<span class="src-str">&quot;PRI&nbsp;KEY&quot;</span><span class="src-sym">,</span><span class="src-str">&quot;objectKey&quot;</span>:<span class="src-str">&quot;RECORD&nbsp;KEY&quot;</span><span class="src-sym">}</span><span class="src-sym">]</span></div></li>
</ol></div></p></p>
	<ul class="tags">
				<li><span class="field">access:</span> public</li>
			</ul>
	
	<div class="method-signature">
		<span class="method-result">unknown</span>
		<span class="method-name">
			buildQuery
		</span>
					(<span class="var-type">[json]</span>&nbsp;<span class="var-name">$json</span>, <span class="var-type">[string]</span>&nbsp;<span class="var-name">$type</span>, [<span class="var-type">[boolean]</span>&nbsp;<span class="var-name">$autoInsert</span> = <span class="var-default">false</span>])
			</div>
	
			<ul class="parameters">
					<li>
				<span class="var-type">[json]</span>
				<span class="var-name">$json</span><span class="var-description">: JSON string like [{&quot;table&quot;:&quot;TABLENAME&quot;,&quot;objectName&quot;:&quot;FIELDNAME&quot;,&quot;objectValue&quot;:&quot;FIELDVALUE&quot;,&quot;database&quot;:&quot;DATABASE&quot;,&quot;tableKey&quot;:&quot;PRI KEY&quot;,&quot;objectKey&quot;:&quot;RECORD KEY&quot;}]</span>			</li>
					<li>
				<span class="var-type">[string]</span>
				<span class="var-name">$type</span><span class="var-description">: INSERT/UPDATE/DELETE</span>			</li>
					<li>
				<span class="var-type">[boolean]</span>
				<span class="var-name">$autoInsert</span><span class="var-description">: = false Auto update database</span>			</li>
				</ul>
		
			
	</div>
<a name="methoddump" id="dump"><!-- --></a>
<div class="evenrow">
	
	<div class="method-header">
		<span class="method-title">dump</span> (line <span class="line-number"><a href="../__filesource/fsource_MySQLService__JSONQuery.php.html#a199">199</a></span>)
	</div> 
	
	<!-- ========== Info from phpDoc block ========= -->
<p class="short-description">I dump vars</p>
	<ul class="tags">
				<li><span class="field">access:</span> public</li>
			</ul>
	
	<div class="method-signature">
		<span class="method-result">void</span>
		<span class="method-name">
			dump
		</span>
					(<span class="var-type">[var]</span>&nbsp;<span class="var-name">$var</span>, [<span class="var-type">[string]</span>&nbsp;<span class="var-name">$name</span> = <span class="var-default">'Variable Dump'</span>])
			</div>
	
			<ul class="parameters">
					<li>
				<span class="var-type">[var]</span>
				<span class="var-name">$var</span>			</li>
					<li>
				<span class="var-type">[string]</span>
				<span class="var-name">$name</span>			</li>
				</ul>
		
			
	</div>
<a name="methodgetJSONArray" id="getJSONArray"><!-- --></a>
<div class="oddrow">
	
	<div class="method-header">
		<span class="method-title">getJSONArray</span> (line <span class="line-number"><a href="../__filesource/fsource_MySQLService__JSONQuery.php.html#a146">146</a></span>)
	</div> 
	
	<!-- ========== Info from phpDoc block ========= -->
	<ul class="tags">
				<li><span class="field">return:</span> array</li>
				<li><span class="field">access:</span> public</li>
			</ul>
	
	<div class="method-signature">
		<span class="method-result">associative</span>
		<span class="method-name">
			getJSONArray
		</span>
				()
			</div>
	
		
			
	</div>
<a name="methodgetJSONString" id="getJSONString"><!-- --></a>
<div class="evenrow">
	
	<div class="method-header">
		<span class="method-title">getJSONString</span> (line <span class="line-number"><a href="../__filesource/fsource_MySQLService__JSONQuery.php.html#a154">154</a></span>)
	</div> 
	
	<!-- ========== Info from phpDoc block ========= -->
	<ul class="tags">
				<li><span class="field">return:</span> string</li>
				<li><span class="field">access:</span> public</li>
			</ul>
	
	<div class="method-signature">
		<span class="method-result">json</span>
		<span class="method-name">
			getJSONString
		</span>
				()
			</div>
	
		
			
	</div>
<a name="methodgetQuery" id="getQuery"><!-- --></a>
<div class="oddrow">
	
	<div class="method-header">
		<span class="method-title">getQuery</span> (line <span class="line-number"><a href="../__filesource/fsource_MySQLService__JSONQuery.php.html#a162">162</a></span>)
	</div> 
	
	<!-- ========== Info from phpDoc block ========= -->
	<ul class="tags">
				<li><span class="field">return:</span> query</li>
				<li><span class="field">access:</span> public</li>
			</ul>
	
	<div class="method-signature">
		<span class="method-result">sql</span>
		<span class="method-name">
			getQuery
		</span>
				()
			</div>
	
		
			
	</div>
<a name="methodsetJSONArray" id="setJSONArray"><!-- --></a>
<div class="evenrow">
	
	<div class="method-header">
		<span class="method-title">setJSONArray</span> (line <span class="line-number"><a href="../__filesource/fsource_MySQLService__JSONQuery.php.html#a170">170</a></span>)
	</div> 
	
	<!-- ========== Info from phpDoc block ========= -->
	<ul class="tags">
				<li><span class="field">access:</span> public</li>
			</ul>
	
	<div class="method-signature">
		<span class="method-result">void</span>
		<span class="method-name">
			setJSONArray
		</span>
					(<span class="var-type"></span>&nbsp;<span class="var-name">$json</span>, <span class="var-type">associative</span>&nbsp;<span class="var-name">$jsonArray</span>)
			</div>
	
			<ul class="parameters">
					<li>
				<span class="var-type">associative</span>
				<span class="var-name">$jsonArray</span>			</li>
					<li>
				<span class="var-type"></span>
				<span class="var-name">$json</span>			</li>
				</ul>
		
			
	</div>
<a name="methodsetJSONQuery" id="setJSONQuery"><!-- --></a>
<div class="oddrow">
	
	<div class="method-header">
		<span class="method-title">setJSONQuery</span> (line <span class="line-number"><a href="../__filesource/fsource_MySQLService__JSONQuery.php.html#a188">188</a></span>)
	</div> 
	
	<!-- ========== Info from phpDoc block ========= -->
	<ul class="tags">
				<li><span class="field">access:</span> public</li>
			</ul>
	
	<div class="method-signature">
		<span class="method-result">void</span>
		<span class="method-name">
			setJSONQuery
		</span>
					(<span class="var-type">string</span>&nbsp;<span class="var-name">$query</span>)
			</div>
	
			<ul class="parameters">
					<li>
				<span class="var-type">string</span>
				<span class="var-name">$query</span>			</li>
				</ul>
		
			
	</div>
<a name="methodsetJSONString" id="setJSONString"><!-- --></a>
<div class="evenrow">
	
	<div class="method-header">
		<span class="method-title">setJSONString</span> (line <span class="line-number"><a href="../__filesource/fsource_MySQLService__JSONQuery.php.html#a180">180</a></span>)
	</div> 
	
	<!-- ========== Info from phpDoc block ========= -->
	<ul class="tags">
				<li><span class="field">access:</span> public</li>
			</ul>
	
	<div class="method-signature">
		<span class="method-result">void</span>
		<span class="method-name">
			setJSONString
		</span>
					(<span class="var-type">json</span>&nbsp;<span class="var-name">$jsonString</span>)
			</div>
	
			<ul class="parameters">
					<li>
				<span class="var-type">json</span>
				<span class="var-name">$jsonString</span>			</li>
				</ul>
		
			
	</div>
<a name="method_batchQuery" id="_batchQuery"><!-- --></a>
<div class="oddrow">
	
	<div class="method-header">
		<span class="method-title">_batchQuery</span> (line <span class="line-number"><a href="../__filesource/fsource_MySQLService__JSONQuery.php.html#a110">110</a></span>)
	</div> 
	
	<!-- ========== Info from phpDoc block ========= -->
<p class="short-description">I take an array of sql statements and execute them in order to the database.</p>
	<ul class="tags">
				<li><span class="field">access:</span> private</li>
			</ul>
	
	<div class="method-signature">
		<span class="method-result">void</span>
		<span class="method-name">
			_batchQuery
		</span>
					(<span class="var-type">[array]</span>&nbsp;<span class="var-name">$sql</span>)
			</div>
	
			<ul class="parameters">
					<li>
				<span class="var-type">[array]</span>
				<span class="var-name">$sql</span><span class="var-description">: array of sql statements</span>			</li>
				</ul>
		
			
	</div>
<a name="method_filterTable" id="_filterTable"><!-- --></a>
<div class="evenrow">
	
	<div class="method-header">
		<span class="method-title">_filterTable</span> (line <span class="line-number"><a href="../__filesource/fsource_MySQLService__JSONQuery.php.html#a122">122</a></span>)
	</div> 
	
	<!-- ========== Info from phpDoc block ========= -->
	<ul class="tags">
				<li><span class="field">access:</span> private</li>
			</ul>
	
	<div class="method-signature">
		<span class="method-result">void</span>
		<span class="method-name">
			_filterTable
		</span>
					(<span class="var-type"></span>&nbsp;<span class="var-name">$s</span>)
			</div>
	
			<ul class="parameters">
					<li>
				<span class="var-type"></span>
				<span class="var-name">$s</span>			</li>
				</ul>
		
			
	</div>
<a name="method_sqlQuote" id="_sqlQuote"><!-- --></a>
<div class="oddrow">
	
	<div class="method-header">
		<span class="method-title">_sqlQuote</span> (line <span class="line-number"><a href="../__filesource/fsource_MySQLService__JSONQuery.php.html#a135">135</a></span>)
	</div> 
	
	<!-- ========== Info from phpDoc block ========= -->
<p class="short-description">Escape SQL</p>
	<ul class="tags">
				<li><span class="field">return:</span> string</li>
				<li><span class="field">access:</span> private</li>
			</ul>
	
	<div class="method-signature">
		<span class="method-result">escaped</span>
		<span class="method-name">
			_sqlQuote
		</span>
					(<span class="var-type">[string]</span>&nbsp;<span class="var-name">$str</span>)
			</div>
	
			<ul class="parameters">
					<li>
				<span class="var-type">[string]</span>
				<span class="var-name">$str</span>			</li>
				</ul>
		
			
	</div>
						
		</div>
	</div>


	<p class="notes" id="credit">
		Documentation generated on Fri, 20 Feb 2009 22:08:33 -0800 by <a href="http://www.phpdoc.org" target="_blank">phpDocumentor 1.4.1</a>
	</p>
	</div></body>
</html>